Creating a filter condition for a specified column
You can create a simple condition for a single column in the table you are working with. You can include any combination of ranges or specific values in the filter and determine whether to include or exclude the defined data.
To create a filter condition:
-
Select a column from the data columns list and then click the right-facing arrow next to the Filter Conditions table.
To remove the column, click on it in the Filter Conditions table and then click the left-facing arrow. Any data entered for this column in the Include/Exclude or Values columns is also deleted.
- Click in the Include/Exclude column to select whether to include or exclude the data that meets this condition.
- Click the Edit Ranges button in the Ranges column.
- The <Name> <Include|Exclude> Ranges window opens. Continue from Adding or removing filter ranges.